package com.yyc.system.dao;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.yyc.core.Mapper;
import com.yyc.system.model.TTeacher;

public interface TTeacherMapper extends Mapper<TTeacher> {

	@Select("SELECT a.*,b.user_name,b.account,c.college_name FROM t_teacher a,t_user b,t_college c WHERE a.user_id = b.id AND a.college_id = c.id ORDER BY a.college_id")
	List<TTeacher> getTeacherList();

	@Select("SELECT a.id,a.user_id,b.user_name,b.account FROM t_teacher a,t_user b WHERE a.user_id = b.id GROUP BY a.college_id")
    List<TTeacher> searchTeacher();
}